Load the Data

After you finish preparing the data in the worksheet, click the Generate DAT File button. The process generates a Zip file that contains the DAT file.

Click Navigator > File Import and Export.

Click the Plus icon in the Search Results table.

Browse and upload the Zip file that has been generated.

Select fin/revenueManagement/import as the account.

Click Save and Close so that the file is placed in the SFTP server or UCM.

Navigate to the Scheduled Processes page and click Schedule New Process.

Select the Load Interface File for Import process.

Select Import Billing Data as the import process.

Select the data file that was placed in the server.

Submit the process to load the data into the interface tables.

Review the results of the process.

Correct Load Errors and Regenerate and Load the DAT File

If the load of the DAT file fails on any row, the Load Interface File for Import process ends in error and the Load File to Interface child process ends in either warning or error. All rows that were loaded from the DAT file are deleted, even those rows that loaded successfully. This lets you edit the problematic data in the spreadsheet and resubmit it without having to separate the successful rows from the rows that need modification.

Review the log and output files of the Load File to Interface child process for information about the data that caused the failure.

Correct the data in the template you used as part of the steps outlined in the Load the Data section.

Repeat steps 1 and 2 in the Load the Data section.

Repeat all of these steps until all data is loaded successfully.

Recommendations for Loading Data

You can generate the DAT file using either of these methods:

Populate the billing data in the template.

Use SQL, ODI, or any similar tool to extract billing data into a DAT file similar in structure to the DAT file generated by the template.

After loading your billing data, you must:

Run the Import Billing Data process to match the billed amount to each corresponding promised detail line.

Run the Recognize Revenue of Customer Contracts process to generate the journal entries to account for the billing of the performance obligation.

If the bill lines fail any validations during processing, they're deleted from the interface tables. In this case, you need to correct the errors and reimport the corrected bill lines.

Once your billing data is processed, you can then review the billed amount at the promised detail, performance obligation, and contract header levels. You can also view the accounting for a specific contract by navigating to the Edit Customer Contracts page and selecting View Accounting.